package com.credithc.signature.common.mapper;

import com.credithc.baseserv.core.mapper.BsBaseMapper;
import com.credithc.signature.common.po.CallChannelHour;
import com.credithc.signature.common.po.CallStatistics;
import com.credithc.signature.common.po.RequestLog;
import com.credithc.signature.common.vo.manager.RequestLogVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.sql.Timestamp;
import java.util.List;

@Mapper
public interface RequestLogMapper extends BsBaseMapper<RequestLog> {

    List<CallChannelHour> StatisticsByTimeGropByChannel(@Param("time") Timestamp time, @Param("beforeTime") Timestamp beforeTime);

    List<CallStatistics> selectCountByStatusGroupByChannel(@Param("status") int i, @Param("time") Timestamp time, @Param("beforeTime") Timestamp beforeTime);

    List<RequestLogVo> StatisticsRequestLog(@Param("startTime") String startTime, @Param("endTime") String endTime, @Param("signStatus") Integer signStatus, @Param("lastTime") Integer lastTime);
}
